Look up both at the same time

For each record in the Customer table, this option looks for a matching record in the Credit table and a matching record in the Orders table. Then it looks for the next matching record in the Credit table and the next matching record in the Orders table, etc. Once it finds all the matching records, it repeats the process with the next record in the Customer table.

Customer Table Credit Table Orders Table
Customer Name Amount Order Amount

Cyclists Incorporated

($1088.56)

$1529.70

Cyclists Incorporated

($1260.12)

$23.50

CyclePath Corp.

($1958.03)

$49.50

CyclePath Corp.

($1076.43)

$1702.60

CyclePath Corp.

($75.04)


The Great Bike Shop

($138.98)

$3269.70

The Great Bike Shop


$5219.55

The Great Bike Shop


$1538.20

Notice that for each line in the report, the value in the Amount field of the Credit table does not necessarily have any connection to the value in the Order Amount field of the Orders table. However, for each record in the Customer table, one record is selected from the Credit table, and one record is selected from the Orders table at the same time.

Also notice that when the Credit table runs out of records for a given record in the Customer table, blanks are left in place of values until all related records from the Orders table are found. The same holds true if the Orders table runs out of records.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com